Loan Default Report

Dataset statistics

Number of variables	13
Number of observations	5960
Missing cells	5271
Missing cells (%)	6.8%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.5 MiB
Average record size in memory	266.3 B

Variable types

Categorical	3
Numeric	10

Warnings

`MORTDUE` has 518 (8.7%) missing values	Missing
`VALUE` has 112 (1.9%) missing values	Missing
`REASON` has 252 (4.2%) missing values	Missing
`JOB` has 279 (4.7%) missing values	Missing
`YOJ` has 515 (8.6%) missing values	Missing
`DEROG` has 708 (11.9%) missing values	Missing
`DELINQ` has 580 (9.7%) missing values	Missing
`CLAGE` has 308 (5.2%) missing values	Missing
`NINQ` has 510 (8.6%) missing values	Missing
`CLNO` has 222 (3.7%) missing values	Missing
`DEBTINC` has 1267 (21.3%) missing values	Missing
`YOJ` has 415 (7.0%) zeros	Zeros
`DEROG` has 4527 (76.0%) zeros	Zeros
`DELINQ` has 4179 (70.1%) zeros	Zeros
`NINQ` has 2531 (42.5%) zeros	Zeros
`CLNO` has 62 (1.0%) zeros	Zeros

Reproduction

Analysis started	2021-01-06 03:28:10.433541
Analysis finished	2021-01-06 03:28:36.154216
Duration	25.72 seconds
Software version	pandas-profiling v2.10.0
Download configuration	config.yaml

BAD
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	337.7 KiB

0	4771
1	1189

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5960
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	0

Value	Count	Frequency (%)
0	4771	80.1%
1	1189	19.9%

Histogram of lengths of the category

Value	Count	Frequency (%)
0	4771	80.1%
1	1189	19.9%

Most occurring characters

Value	Count	Frequency (%)
0	4771	80.1%
1	1189	19.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5960	100.0%

Most frequent character per category

Value	Count	Frequency (%)
0	4771	80.1%
1	1189	19.9%

Most occurring scripts

Value	Count	Frequency (%)
Common	5960	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	4771	80.1%
1	1189	19.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5960	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	4771	80.1%
1	1189	19.9%

LOAN
Real number (ℝ_≥0)

Distinct	540
Distinct (%)	9.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	18607.9698
Minimum	1100
Maximum	89900
Zeros	0
Zeros (%)	0.0%
Memory size	46.7 KiB

Quantile statistics

Minimum	1100
5-th percentile	5900
Q1	11100
median	16300
Q3	23300
95-th percentile	40000
Maximum	89900
Range	88800
Interquartile range (IQR)	12200

Descriptive statistics

Standard deviation	11207.48042
Coefficient of variation (CV)	0.6022946371
Kurtosis	6.932589768
Mean	18607.9698
Median Absolute Deviation (MAD)	6000
Skewness	2.023780712
Sum	110903500
Variance	125607617.3
Monotocity	Increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15000	105	1.8%
10000	81	1.4%
20000	74	1.2%
25000	73	1.2%
12000	69	1.2%
17000	51	0.9%
13000	50	0.8%
5000	50	0.8%
11000	47	0.8%
8000	44	0.7%
Other values (530)	5316	89.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1100	1	< 0.1%
1300	1	< 0.1%
1500	2	< 0.1%
1700	2	< 0.1%
1800	2	< 0.1%
2000	6	0.1%
2100	1	< 0.1%
2200	3	0.1%
2300	3	0.1%
2400	6	0.1%

Value	Count	Frequency (%)
89900	1	< 0.1%
89800	1	< 0.1%
89200	1	< 0.1%
89000	1	< 0.1%
88900	2	< 0.1%
88800	1	< 0.1%
88500	1	< 0.1%
88300	1	< 0.1%
87500	1	< 0.1%
87000	1	< 0.1%

MORTDUE
Real number (ℝ_≥0)

MISSING

Distinct	5053
Distinct (%)	92.9%
Missing	518
Missing (%)	8.7%
Infinite	0
Infinite (%)	0.0%

Mean	73760.8172
Minimum	2063
Maximum	399550
Zeros	0
Zeros (%)	0.0%
Memory size	46.7 KiB

Quantile statistics

Minimum	2063
5-th percentile	18232.4
Q1	46276
median	65019
Q3	91488
95-th percentile	151999.55
Maximum	399550
Range	397487
Interquartile range (IQR)	45212

Descriptive statistics

Standard deviation	44457.60946
Coefficient of variation (CV)	0.6027266392
Kurtosis	6.481866314
Mean	73760.8172
Median Absolute Deviation (MAD)	21655.5
Skewness	1.814480702
Sum	401406367.2
Variance	1976479039
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
42000	11	0.2%
47000	10	0.2%
65000	9	0.2%
45000	7	0.1%
50000	7	0.1%
124000	7	0.1%
70000	7	0.1%
62000	7	0.1%
55000	7	0.1%
58000	6	0.1%
Other values (5043)	5364	90.0%
(Missing)	518	8.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2063	1	< 0.1%
2619	1	< 0.1%
2800	1	< 0.1%
3372	1	< 0.1%
4000	1	< 0.1%
4447	1	< 0.1%
4500	1	< 0.1%
4641	1	< 0.1%
4734	1	< 0.1%
4742	1	< 0.1%

Value	Count	Frequency (%)
399550	1	< 0.1%
399412	1	< 0.1%
397299	1	< 0.1%
391000	1	< 0.1%
371003	1	< 0.1%
369874	1	< 0.1%
367917	1	< 0.1%
367089	1	< 0.1%
365528	1	< 0.1%
363737	1	< 0.1%

VALUE
Real number (ℝ_≥0)

MISSING

Distinct	5381
Distinct (%)	92.0%
Missing	112
Missing (%)	1.9%
Infinite	0
Infinite (%)	0.0%

Mean	101776.0487
Minimum	8000
Maximum	855909
Zeros	0
Zeros (%)	0.0%
Memory size	46.7 KiB

Quantile statistics

Minimum	8000
5-th percentile	39050.7
Q1	66075.5
median	89235.5
Q3	119824.25
95-th percentile	203717.2
Maximum	855909
Range	847909
Interquartile range (IQR)	53748.75

Descriptive statistics

Standard deviation	57385.77533
Coefficient of variation (CV)	0.5638436159
Kurtosis	24.36280488
Mean	101776.0487
Median Absolute Deviation (MAD)	25764.5
Skewness	3.053344267
Sum	595186333
Variance	3293127211
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
60000	15	0.3%
80000	14	0.2%
85000	12	0.2%
65000	11	0.2%
78000	10	0.2%
72000	9	0.2%
68000	8	0.1%
87000	8	0.1%
50000	8	0.1%
105000	7	0.1%
Other values (5371)	5746	96.4%
(Missing)	112	1.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
8000	1	< 0.1%
8800	1	< 0.1%
9100	1	< 0.1%
9500	1	< 0.1%
11550	1	< 0.1%
11702	1	< 0.1%
12414	1	< 0.1%
12500	1	< 0.1%
12737	1	< 0.1%
12972	1	< 0.1%

Value	Count	Frequency (%)
855909	1	< 0.1%
854114	1	< 0.1%
854112	1	< 0.1%
850000	1	< 0.1%
512650	1	< 0.1%
511164	1	< 0.1%
505000	1	< 0.1%
471827	1	< 0.1%
469771	1	< 0.1%
469748	1	< 0.1%

REASON
Categorical

MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	252
Missing (%)	4.2%
Memory size	543.1 KiB

DebtCon	3928
HomeImp	1780

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	39956
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	HomeImp
2nd row	HomeImp
3rd row	HomeImp
4th row	HomeImp
5th row	HomeImp

Value	Count	Frequency (%)
DebtCon	3928	65.9%
HomeImp	1780	29.9%
(Missing)	252	4.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
debtcon	3928	68.8%
homeimp	1780	31.2%

Most occurring characters

Value	Count	Frequency (%)
o	5708	14.3%
e	5708	14.3%
D	3928	9.8%
b	3928	9.8%
t	3928	9.8%
C	3928	9.8%
n	3928	9.8%
m	3560	8.9%
H	1780	4.5%
I	1780	4.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	28540	71.4%
Uppercase Letter	11416	28.6%

Most frequent character per category

Value	Count	Frequency (%)
o	5708	20.0%
e	5708	20.0%
b	3928	13.8%
t	3928	13.8%
n	3928	13.8%
m	3560	12.5%
p	1780	6.2%

Value	Count	Frequency (%)
D	3928	34.4%
C	3928	34.4%
H	1780	15.6%
I	1780	15.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	39956	100.0%

Most frequent character per script

Value	Count	Frequency (%)
o	5708	14.3%
e	5708	14.3%
D	3928	9.8%
b	3928	9.8%
t	3928	9.8%
C	3928	9.8%
n	3928	9.8%
m	3560	8.9%
H	1780	4.5%
I	1780	4.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	39956	100.0%

Most frequent character per block

Value	Count	Frequency (%)
o	5708	14.3%
e	5708	14.3%
D	3928	9.8%
b	3928	9.8%
t	3928	9.8%
C	3928	9.8%
n	3928	9.8%
m	3560	8.9%
H	1780	4.5%
I	1780	4.5%

JOB
Categorical

MISSING

Distinct	6
Distinct (%)	0.1%
Missing	279
Missing (%)	4.7%
Memory size	494.6 KiB

Other	2388
ProfExe	1276
Office	948
Mgr	767
Self	193

Length

Max length	7
Median length	5
Mean length	5.312092941
Min length	3

Characters and Unicode

Total characters	30178
Distinct characters	18
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Other
2nd row	Other
3rd row	Other
4th row	Office
5th row	Other

Value	Count	Frequency (%)
Other	2388	40.1%
ProfExe	1276	21.4%
Office	948	15.9%
Mgr	767	12.9%
Self	193	3.2%
Sales	109	1.8%
(Missing)	279	4.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
other	2388	42.0%
profexe	1276	22.5%
office	948	16.7%
mgr	767	13.5%
self	193	3.4%
sales	109	1.9%

Most occurring characters

Value	Count	Frequency (%)
e	4914	16.3%
r	4431	14.7%
f	3365	11.2%
O	3336	11.1%
t	2388	7.9%
h	2388	7.9%
P	1276	4.2%
o	1276	4.2%
E	1276	4.2%
x	1276	4.2%
Other values (8)	4252	14.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	23221	76.9%
Uppercase Letter	6957	23.1%

Most frequent character per category

Value	Count	Frequency (%)
e	4914	21.2%
r	4431	19.1%
f	3365	14.5%
t	2388	10.3%
h	2388	10.3%
o	1276	5.5%
x	1276	5.5%
i	948	4.1%
c	948	4.1%
g	767	3.3%
Other values (3)	520	2.2%

Value	Count	Frequency (%)
O	3336	48.0%
P	1276	18.3%
E	1276	18.3%
M	767	11.0%
S	302	4.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	30178	100.0%

Most frequent character per script

Value	Count	Frequency (%)
e	4914	16.3%
r	4431	14.7%
f	3365	11.2%
O	3336	11.1%
t	2388	7.9%
h	2388	7.9%
P	1276	4.2%
o	1276	4.2%
E	1276	4.2%
x	1276	4.2%
Other values (8)	4252	14.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	30178	100.0%

Most frequent character per block

Value	Count	Frequency (%)
e	4914	16.3%
r	4431	14.7%
f	3365	11.2%
O	3336	11.1%
t	2388	7.9%
h	2388	7.9%
P	1276	4.2%
o	1276	4.2%
E	1276	4.2%
x	1276	4.2%
Other values (8)	4252	14.1%

YOJ
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	99
Distinct (%)	1.8%
Missing	515
Missing (%)	8.6%
Infinite	0
Infinite (%)	0.0%

Mean	8.922268136
Minimum	0
Maximum	41
Zeros	415
Zeros (%)	7.0%
Memory size	46.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	3
median	7
Q3	13
95-th percentile	24
Maximum	41
Range	41
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	7.573982249
Coefficient of variation (CV)	0.8488852984
Kurtosis	0.3720724789
Mean	8.922268136
Median Absolute Deviation (MAD)	5
Skewness	0.9884600695
Sum	48581.75
Variance	57.36520711
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	415	7.0%
1	363	6.1%
2	347	5.8%
5	333	5.6%
4	324	5.4%
6	318	5.3%
3	307	5.2%
9	286	4.8%
10	285	4.8%
8	256	4.3%
Other values (89)	2211	37.1%
(Missing)	515	8.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	415	7.0%
0.1	14	0.2%
0.2	10	0.2%
0.25	1	< 0.1%
0.3	7	0.1%
0.4	9	0.2%
0.5	7	0.1%
0.6	4	0.1%
0.7	4	0.1%
0.75	2	< 0.1%

Value	Count	Frequency (%)
41	3	0.1%
36	5	0.1%
35	5	0.1%
34	2	< 0.1%
33	2	< 0.1%
32	1	< 0.1%
31	12	0.2%
30	30	0.5%
29.9	1	< 0.1%
29	29	0.5%

DEROG
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	11
Distinct (%)	0.2%
Missing	708
Missing (%)	11.9%
Infinite	0
Infinite (%)	0.0%

Mean	0.2545696877
Minimum	0
Maximum	10
Zeros	4527
Zeros (%)	76.0%
Memory size	46.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2
Maximum	10
Range	10
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.8460467771
Coefficient of variation (CV)	3.323438798
Kurtosis	36.87276339
Mean	0.2545696877
Median Absolute Deviation (MAD)	0
Skewness	5.32087025
Sum	1337
Variance	0.715795149
Monotocity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
0	4527	76.0%
1	435	7.3%
2	160	2.7%
3	58	1.0%
4	23	0.4%
6	15	0.3%
5	15	0.3%
7	8	0.1%
8	6	0.1%
9	3	0.1%
(Missing)	708	11.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4527	76.0%
1	435	7.3%
2	160	2.7%
3	58	1.0%
4	23	0.4%
5	15	0.3%
6	15	0.3%
7	8	0.1%
8	6	0.1%
9	3	0.1%

Value	Count	Frequency (%)
10	2	< 0.1%
9	3	0.1%
8	6	0.1%
7	8	0.1%
6	15	0.3%
5	15	0.3%
4	23	0.4%
3	58	1.0%
2	160	2.7%
1	435	7.3%

DELINQ
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	14
Distinct (%)	0.3%
Missing	580
Missing (%)	9.7%
Infinite	0
Infinite (%)	0.0%

Mean	0.4494423792
Minimum	0
Maximum	15
Zeros	4179
Zeros (%)	70.1%
Memory size	46.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	3
Maximum	15
Range	15
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.127265918
Coefficient of variation (CV)	2.508143357
Kurtosis	23.56544868
Mean	0.4494423792
Median Absolute Deviation (MAD)	0
Skewness	4.023149577
Sum	2418
Variance	1.270728449
Monotocity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
0	4179	70.1%
1	654	11.0%
2	250	4.2%
3	129	2.2%
4	78	1.3%
5	38	0.6%
6	27	0.5%
7	13	0.2%
8	5	0.1%
11	2	< 0.1%
Other values (4)	5	0.1%
(Missing)	580	9.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4179	70.1%
1	654	11.0%
2	250	4.2%
3	129	2.2%
4	78	1.3%
5	38	0.6%
6	27	0.5%
7	13	0.2%
8	5	0.1%
10	2	< 0.1%

Value	Count	Frequency (%)
15	1	< 0.1%
13	1	< 0.1%
12	1	< 0.1%
11	2	< 0.1%
10	2	< 0.1%
8	5	0.1%
7	13	0.2%
6	27	0.5%
5	38	0.6%
4	78	1.3%

CLAGE
Real number (ℝ_≥0)

MISSING

Distinct	5314
Distinct (%)	94.0%
Missing	308
Missing (%)	5.2%
Infinite	0
Infinite (%)	0.0%

Mean	179.7662752
Minimum	0
Maximum	1168.233561
Zeros	2
Zeros (%)	< 0.1%
Memory size	46.7 KiB

Quantile statistics

Minimum	0
5-th percentile	68.9126539
Q1	115.1167022
median	173.4666667
Q3	231.5622781
95-th percentile	321.6333333
Maximum	1168.233561
Range	1168.233561
Interquartile range (IQR)	116.4455759

Descriptive statistics

Standard deviation	85.81009176
Coefficient of variation (CV)	0.4773425476
Kurtosis	7.599549329
Mean	179.7662752
Median Absolute Deviation (MAD)	58.27041147
Skewness	1.343412043
Sum	1016038.987
Variance	7363.371848
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
102.5	7	0.1%
206.9666667	7	0.1%
177.5	6	0.1%
109.5666667	6	0.1%
123.7666667	6	0.1%
95.36666667	6	0.1%
117.6666667	5	0.1%
219.1333333	5	0.1%
232.3333333	5	0.1%
107.5333333	5	0.1%
Other values (5304)	5594	93.9%
(Missing)	308	5.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	< 0.1%
0.4867114508	1	< 0.1%
0.5071145295	1	< 0.1%
2.033333333	1	< 0.1%
2.820785578	1	< 0.1%
3.04438414	1	< 0.1%
4.412770061	1	< 0.1%
5.243341044	1	< 0.1%
6.133333333	1	< 0.1%
8.055265077	1	< 0.1%

Value	Count	Frequency (%)
1168.233561	1	< 0.1%
1154.633333	1	< 0.1%
649.7471044	1	< 0.1%
648.3284926	1	< 0.1%
639.0581723	1	< 0.1%
638.2753611	1	< 0.1%
634.4618926	1	< 0.1%
632.1031857	1	< 0.1%
630.0333333	1	< 0.1%
629.0957663	1	< 0.1%

NINQ
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	16
Distinct (%)	0.3%
Missing	510
Missing (%)	8.6%
Infinite	0
Infinite (%)	0.0%

Mean	1.186055046
Minimum	0
Maximum	17
Zeros	2531
Zeros (%)	42.5%
Memory size	46.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	4
Maximum	17
Range	17
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.728674971
Coefficient of variation (CV)	1.457499782
Kurtosis	9.786507278
Mean	1.186055046
Median Absolute Deviation (MAD)	1
Skewness	2.621984172
Sum	6464
Variance	2.988317156
Monotocity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
0	2531	42.5%
1	1339	22.5%
2	780	13.1%
3	392	6.6%
4	156	2.6%
5	75	1.3%
6	56	0.9%
7	44	0.7%
10	28	0.5%
8	22	0.4%
Other values (6)	27	0.5%
(Missing)	510	8.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2531	42.5%
1	1339	22.5%
2	780	13.1%
3	392	6.6%
4	156	2.6%
5	75	1.3%
6	56	0.9%
7	44	0.7%
8	22	0.4%
9	11	0.2%

Value	Count	Frequency (%)
17	1	< 0.1%
14	1	< 0.1%
13	2	< 0.1%
12	2	< 0.1%
11	10	0.2%
10	28	0.5%
9	11	0.2%
8	22	0.4%
7	44	0.7%
6	56	0.9%

CLNO
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	62
Distinct (%)	1.1%
Missing	222
Missing (%)	3.7%
Infinite	0
Infinite (%)	0.0%

Mean	21.2960962
Minimum	0
Maximum	71
Zeros	62
Zeros (%)	1.0%
Memory size	46.7 KiB

Quantile statistics

Minimum	0
5-th percentile	7
Q1	15
median	20
Q3	26
95-th percentile	40
Maximum	71
Range	71
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	10.13893319
Coefficient of variation (CV)	0.4760935101
Kurtosis	1.157672732
Mean	21.2960962
Median Absolute Deviation (MAD)	6
Skewness	0.7750517583
Sum	122197
Variance	102.7979663
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16	316	5.3%
19	307	5.2%
24	264	4.4%
23	259	4.3%
21	235	3.9%
20	231	3.9%
18	225	3.8%
25	221	3.7%
15	217	3.6%
22	212	3.6%
Other values (52)	3251	54.5%
(Missing)	222	3.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	62	1.0%
1	6	0.1%
2	15	0.3%
3	34	0.6%
4	42	0.7%
5	47	0.8%
6	60	1.0%
7	76	1.3%
8	92	1.5%
9	127	2.1%

Value	Count	Frequency (%)
71	2	< 0.1%
65	3	0.1%
64	5	0.1%
63	1	< 0.1%
58	3	0.1%
57	1	< 0.1%
56	6	0.1%
55	14	0.2%
53	2	< 0.1%
52	5	0.1%

DEBTINC
Real number (ℝ_≥0)

MISSING

Distinct	4693
Distinct (%)	100.0%
Missing	1267
Missing (%)	21.3%
Infinite	0
Infinite (%)	0.0%

Mean	33.77991535
Minimum	0.5244992154
Maximum	203.3121487
Zeros	0
Zeros (%)	0.0%
Memory size	46.7 KiB

Quantile statistics

Minimum	0.5244992154
5-th percentile	20.51188558
Q1	29.14003137
median	34.81826182
Q3	39.00314063
95-th percentile	42.76785245
Maximum	203.3121487
Range	202.7876495
Interquartile range (IQR)	9.863109256

Descriptive statistics

Standard deviation	8.601746186
Coefficient of variation (CV)	0.2546408449
Kurtosis	50.50404153
Mean	33.77991535
Median Absolute Deviation (MAD)	4.814928269
Skewness	2.852353416
Sum	158529.1427
Variance	73.99003745
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
42.435285	1	< 0.1%
40.56013033	1	< 0.1%
12.38674131	1	< 0.1%
38.70999145	1	< 0.1%
33.96477734	1	< 0.1%
39.8272172	1	< 0.1%
28.74989037	1	< 0.1%
40.25722171	1	< 0.1%
36.26033127	1	< 0.1%
34.41650781	1	< 0.1%
Other values (4683)	4683	78.6%
(Missing)	1267	21.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.5244992154	1	< 0.1%
0.7202950067	1	< 0.1%
0.8381175254	1	< 0.1%
1.028930968	1	< 0.1%
1.565931047	1	< 0.1%
1.603507978	1	< 0.1%
1.85553998	1	< 0.1%
1.909225163	1	< 0.1%
1.920694367	1	< 0.1%
2.365195413	1	< 0.1%

Value	Count	Frequency (%)
203.3121487	1	< 0.1%
144.1890013	1	< 0.1%
143.949605	1	< 0.1%
133.5282704	1	< 0.1%
114.0505277	1	< 0.1%
91.61259998	1	< 0.1%
84.61388869	1	< 0.1%
84.37903408	1	< 0.1%
78.65438605	1	< 0.1%
76.42147805	1	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	BAD	LOAN	MORTDUE	VALUE	REASON	JOB	YOJ	DEROG	DELINQ	CLAGE	NINQ	CLNO	DEBTINC
0	1	1100	25860.0	39025.0	HomeImp	Other	10.5	0.0	0.0	94.366667	1.0	9.0	NaN
1	1	1300	70053.0	68400.0	HomeImp	Other	7.0	0.0	2.0	121.833333	0.0	14.0	NaN
2	1	1500	13500.0	16700.0	HomeImp	Other	4.0	0.0	0.0	149.466667	1.0	10.0	NaN
3	1	1500	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
4	0	1700	97800.0	112000.0	HomeImp	Office	3.0	0.0	0.0	93.333333	0.0	14.0	NaN
5	1	1700	30548.0	40320.0	HomeImp	Other	9.0	0.0	0.0	101.466002	1.0	8.0	37.113614
6	1	1800	48649.0	57037.0	HomeImp	Other	5.0	3.0	2.0	77.100000	1.0	17.0	NaN
7	1	1800	28502.0	43034.0	HomeImp	Other	11.0	0.0	0.0	88.766030	0.0	8.0	36.884894
8	1	2000	32700.0	46740.0	HomeImp	Other	3.0	0.0	2.0	216.933333	1.0	12.0	NaN
9	1	2000	NaN	62250.0	HomeImp	Sales	16.0	0.0	0.0	115.800000	0.0	13.0	NaN

Last rows

	LOAN	MORTDUE	VALUE	REASON	JOB	YOJ	DELINQ	CLAGE	CLNO	DEBTINC
5950	87500	55938.0	86794.0	DebtCon	Other	15.0	0.0	223.881040	16.0	36.753653
5951	88300	54004.0	94838.0	DebtCon	Other	16.0	0.0	193.702051	15.0	36.262691
5952	88500	50240.0	94687.0	DebtCon	Other	16.0	0.0	214.426206	16.0	34.751158
5953	88800	53307.0	94058.0	DebtCon	Other	16.0	0.0	218.304978	15.0	34.242465
5954	88900	48919.0	93371.0	DebtCon	Other	15.0	1.0	205.650159	15.0	34.818262
5955	88900	57264.0	90185.0	DebtCon	Other	16.0	0.0	221.808718	16.0	36.112347
5956	89000	54576.0	92937.0	DebtCon	Other	16.0	0.0	208.692070	15.0	35.859971
5957	89200	54045.0	92924.0	DebtCon	Other	15.0	0.0	212.279697	15.0	35.556590
5958	89800	50370.0	91861.0	DebtCon	Other	14.0	0.0	213.892709	16.0	34.340882
5959	89900	48811.0	88934.0	DebtCon	Other	15.0	0.0	219.601002	16.0	34.571519

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows